<style type="text/css">
.searchborder
{
	border:1px solid #999;
	font-family:Verdana, Geneva, sans-serif;
	font-size:12px;
	padding:5px 5px 5px 5px;
	font-weight:normal;
	color:#000;
}
</style>
<?php 
include("application/base_class.php");
$base_obj = new BaseClass();

$q=$_GET["q"];
 $city='';
 $qry ="SELECT z.zone_name,c.city_id,c.city_name,c.active_status FROM city c INNER JOIN zone z ON z.id=c.zone_id 
						where z.id='".$q."' order by c.city_id desc";
$res = mysql_query($qry);


if(mysql_num_rows($res)>0)
	 {
		 $city .='<select name="city" class="searchborder" style="width:220px;"><option value="">--Select City--</option>';
		 while($data=mysql_fetch_array($res)) 
		{
			$city .='<option value="'.$data['city_id'].'" >'.$data['city_name'].'</option>';
			
		}
		$city .='</select>';
		echo $city;	
	}
	else
	{
	    $city .='<select name="city" class="searchborder" style="width:220px;"  ><option value="">--Select City--</option>';
		$city .='<option value="No Data Found">No Data Found</option>';
		$city .='</select>';
		echo $city;	
	}
 
?> 
	